select distinct finger_unit.nopasien as id, upper(finger_unit.obat) as obat,upper(finger_unit.kasir) as kasir, upper(finger_unit.namapasien) as nama, upper(finger_unit.jenispasien) as jenis, upper(finger_unit.status) as statussidik,finger_unit.nourut as nourut,finger_unit.kode as kode,finger_unit.nokartu as no_kartu,finger_unit.umur as umur,finger_unit.poli as poli,keterangan, flag from finger_unit inner join units on "obat" = finger_unit.unitid where units.id = "97" and substring(finger_unit.tanggalfingger,1,10) = "2020-01-22" and finger_unit.status = "sudah"  order by finger_unit.obat,finger_unit.nourut 
